Anson Cheung ✭✭✭✭

Overview

Overview

Roles	Member
Badges	11

About Me

About Me

Not much happening here, yet.

Analytics

27

Posts

41

Visits

561

Points

Mar 28, 2022

Join Date

Nov 6, 2023

Last Active

Reactions

• Vote Up 4

  4
• Awesome 5

  5

• Activity
• Discussions
• Comments27

• Re: Multi-part formula with multi select field using references issue

  Anson Cheung

  06/09/23
  Hi Kimberly, try this. =COUNTIFS({Student Type}, "University Student", {Student Availability}, HAS(@cell, "Monday AM")) --Anson
  1 ·

• Re: Calculate workday duration between two dates?

  Anson Cheung

  04/06/23
  Hi Claire, you may look into the formula function NETWORKDAYS() https://help.smartsheet.com/function/networkdays --Anson
  1 ·

• Re: Formula to Collate Entries based on Criteria

  Anson Cheung

  03/27/23
  Hi Cheryl, Not quite sure if this is what you want. You can use JOIN() + COLLECT() to select by criteria and concatenate them in a cell for an overall update. E.g. --Anson
  2 ·